shuppy (@delan) — [archived] 2023-12-17T11:48:16.822Z

shuppy (@delan) — [archived] 2023-12-17T11:45:30.540Z

no one ever told me excel 2000 add-ins were just excel spreadsheets with dipping mustards (.xla)?

an excel spreadsheet with small square cells and gridlines on, containing buttons and input fields for a Template Wizard - Step 3 of 5

$an excel spreadsheet with small square cells, containing buttons and input fields for a Template Wizard - Step 1 of 5, with a path field that reads “C:\MSOffice\Templates\It's a 'test”$ $an excel spreadsheet with small square cells, containing buttons and input fields for a Template Wizard - Step 2 of 5, with a path field that reads “C:\work\xl96\wizard\It's a 'test Database”$

an excel spreadsheet with small square cells, containing buttons and input fields for a Template Wizard - Step 5 of 5, and a very 90s graphic of a waving checkered finishing flag

@bark and i were tryna figure out how formulas worked under the hood, when we found some strange xla files on the install cd.

we couldn’t figure out how to edit them in excel — opening them in excel would just do nothing — but we were able to open them in libreoffice calc, and, well.

shuppy (@delan) — [archived] 2023-12-17T11:48:16.822Z

you’re kidding

an excel spreadsheet with the text “StubData Named Range” in A1, then A3 below that read

IF(ISERROR(MATCH("%ADDINNAME%"), DOCUMENTS(3), 0)))
ERROR(FALSE)
[…]
ALERT("%CANNOTFINDALERT%")
RETURN()
END.IF()
END.IF()
RUN("%ADDINNAME%!AutoOpenFromTemplate")
RETURN()

an excel spreadsheet with the text “DIALOG TEXT” near a box with a thick border that reads “Report Manager”, “&Print…”, “Close”, “&Help”, “&Add…”, “&Edit…”, “De&lete”, “&Reports:”, and “ud01a.reports.”

they use a formula-like programming language that can (what looks like) call into dlls, and they define ui strings in the spreadsheet?

shuppy (@delan) — [archived] 2023-12-17T11:45:30.540Z

no one ever told me excel 2000 add-ins were just excel spreadsheets with dipping mustards (.xla)?

$an excel spreadsheet with small square cells, containing buttons and input fields for a Template Wizard - Step 1 of 5, with a path field that reads “C:\MSOffice\Templates\It's a 'test”$ $an excel spreadsheet with small square cells, containing buttons and input fields for a Template Wizard - Step 2 of 5, with a path field that reads “C:\work\xl96\wizard\It's a 'test Database”$

@bark and i were tryna figure out how formulas worked under the hood, when we found some strange xla files on the install cd.

we couldn’t figure out how to edit them in excel — opening them in excel would just do nothing — but we were able to open them in libreoffice calc, and, well.

shuppy (@delan) — [archived] 2023-10-11T16:45:32.992Z

shuppy (@delan) — [archived] 2023-10-11T11:53:31.959Z

this must be what Gamers mean when they’re like “i would simply turn up the optimisations”

shuppy (@delan) — [archived] 2023-10-11T12:30:59.529Z

can the symbol tree stop fucking collapsing when i undo or redo.

i need to see how im supposed to name things, i have no fucking object permanence

shuppy (@delan) — [archived] 2023-10-11T16:10:57.977Z

annotated a whole bunch of puzzle-related code

really liking ghidra’s namespaces feature ^w^

Puzzles::CheckEndgame
Puzzles::ComputeCandidateCategory
Puzzles::ComputeCandidatePuzzles
Puzzles::TurnAllOffCategoriesBackOn
Puzzles::Customization::draw

https://github.com/delan/reverssg/compare/3d2da8095cd3b793d66548a90c10d0bca6d6b0d6...b568ce1bf7a7b64113a1c42c9ebf76befb2f97d7

shuppy (@delan) — [archived] 2023-10-11T16:45:32.992Z

enums can be used to buy goods and services

diff annotated.c, showing integer comparisons being changed to enum variant comparisons, and a comment that reads “if category is on (normal) or on (endgame)” being removed

diff annotated.h, showing a new typedef enum Puzzle::CategoryMode, the PuzzleState.mode being changed from undefined2 to that new type, and the comment that reads “0 = on, 1 = off, 2 = fully solved, 3 = on (endgame), 4 = off (endgame)” being removed

(ty @ariashark)

shuppy (@delan) — [archived] 2023-10-11T16:10:57.977Z

shuppy (@delan) — [archived] 2023-10-11T11:53:31.959Z

this must be what Gamers mean when they’re like “i would simply turn up the optimisations”

shuppy (@delan) — [archived] 2023-10-11T12:30:59.529Z

can the symbol tree stop fucking collapsing when i undo or redo.

i need to see how im supposed to name things, i have no fucking object permanence

shuppy (@delan) — [archived] 2023-10-11T16:10:57.977Z

annotated a whole bunch of puzzle-related code

really liking ghidra’s namespaces feature ^w^

Puzzles::CheckEndgame
Puzzles::ComputeCandidateCategory
Puzzles::ComputeCandidatePuzzles
Puzzles::TurnAllOffCategoriesBackOn
Puzzles::Customization::draw

https://github.com/delan/reverssg/compare/3d2da8095cd3b793d66548a90c10d0bca6d6b0d6...b568ce1bf7a7b64113a1c42c9ebf76befb2f97d7

shuppy (@delan) — [archived] 2023-10-11T12:30:59.529Z

shuppy (@delan) — [archived] 2023-10-11T11:53:31.959Z

this must be what Gamers mean when they’re like “i would simply turn up the optimisations”

shuppy (@delan) — [archived] 2023-10-11T12:30:59.529Z

can the symbol tree stop fucking collapsing when i undo or redo.

i need to see how im supposed to name things, i have no fucking object permanence

shuppy (@delan) — [archived] 2023-10-11T11:53:31.959Z

this must be what Gamers mean when they’re like “i would simply turn up the optimisations”

shuppy (@delan) — [archived] 2023-05-18T16:50:09.267Z

worstpractice, a viewer for Bp Premier XML patient records

left: the start of my patient record, with all of the actual values redacted. right: partially redacted ecg from my patient record.

i asked my old gp for a copy of my patient record in the same xml format they use for transfers. like many gp places in australia nowadays, they use best practice (bp premier).

anyway here’s a rudimentary viewer for bp premier xml patient records:

https://bucket.daz.cat/worstpractice/